PostgreSQL Cookbook by Unknown

Author:Unknown
Language: eng
Format: epub
Publisher: Packt Publishing

Chapter 7. High Availability and Replication

In this chapter, we will cover the following recipes:

Setting up hot streaming replication

Replication using Slony-I

Replication using Londiste

Replication using Bucardo

Replication using DRBD

Setting up the Postgres-XC cluster

Introduction

The important components for any production database is to achieve fault tolerance, 24/7 availability, and redundancy. It is for this purpose that we have different high availability and replication solutions available for PostgreSQL.

From a business perspective, it is important to ensure 24/7 data availability in the event of a disaster situation or a database crash due to disk or hardware failure. In such situations, it becomes critical to ensure that a duplicate copy of the data is available on a different server or a different database, so that seamless failover can be achieved even when the primary server/database is unavailable.

In this chapter, we will talk about various high availability and replication solutions, including some popular third-party replication tools such as Slony-I, Londiste, and Bucardo. We will also discuss block-level replication using DRBD, and finally, set up a PostgreSQL extensible cluster, that is, Postgres-XC.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.